﻿CREATE TABLE [dbo].[GoodsReceivedNoteItem] (
    [Id]                  UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [PurchaseOrderItemId] UNIQUEIDENTIFIER NULL,
    [QuantityDelivered]   DECIMAL (18)     NULL,
    [QuantityDamaged]     DECIMAL (18)     NULL,
    [Comments]            NTEXT            NULL,
    [GoodsReceivedNoteId] UNIQUEIDENTIFIER NOT NULL,
    [ItemId]              UNIQUEIDENTIFIER NOT NULL
);

